<?php
/**
 * 活动细节
 *
 *
 *
 *
 * @copyright  Copyright (c) 2007-2016 ShopNC Inc. (http://www.shopnc.net)
 * @license    http://www.shopnc.net
 * @link       http://www.shopnc.net
 * @since      File available since Release v1.1
 */
defined('InShopNC') or exit('Access Invalid!');
class activity_detailModel extends Model {
    /**
     * 添加
     *
     * @param array $input
     * @return bool
     */
    public function add($input){
        return $this->insert1('activity_detail',$input);
    }
    /**
     * 更新
     *
     * @param array $input 更新内容
     * @param string $id 活动内容id
     * @return bool
     */
    public function updates($input,$id){
        return $this->update1('activity_detail',$input,'activity_detail_id in('.$id.')');
    }
    /**
     * 根据条件更新
     *
     * @param array $input 更新内容
     * @param array $condition 更新条件
     * @return bool
     */
    public function updateList($input,$condition){
        return $this->update1('activity_detail',$input,$this->getCondition($condition));
    }
    /**
     * 删除
     *
     * @param string $id
     * @return bool
     */
    public function del($id){
        return $this->delete1('activity_detail','activity_detail_id in('.$id.')');
    }
    /**
     * 根据条件删除
     *
     * @param array $condition 条件数组
     * @return bool
     */
    public function delList($condition){
        return $this->delete1('activity_detail',$this->getCondition($condition));
    }
    /**
     * 根据条件查询活动内容信息
     *
     * @param array $condition 查询条件数组
     * @param obj $page 分页对象
     * @return array 二维数组
     */
    public function getList($condition,$page=''){
        $param  = array();
        $param['table'] = 'activity_detail';
        $param['where'] = $this->getCondition($condition);
        $param['order'] = $condition['order'];
        return $this->select1($param,$page);
    }
    /**
     * 根据条件查询活动商品内容信息
     *
     * @param array $condition 查询条件数组
     * @param obj $page 分页对象
     * @return array 二维数组
     */
    public function getGoodsJoinList($condition,$page=''){
        $param  = array();
        $param['table'] = 'activity_detail,goods';
        $param['join_type'] = 'inner join';
        $param['field'] = 'activity_detail.activity_detail_id,activity_detail.activity_id,activity_detail.item_id,activity_detail.item_name,activity_detail.activity_detail_state,activity_detail.activity_detail_sort,goods.*';
        $param['join_on']   = array('activity_detail.item_id=goods.goods_id');
        $param['where'] = $this->getCondition($condition);
        $param['order'] = $condition['order'];
        return $this->select1($param,$page);
    }
    /**
     * 查询活动商品信息
     *
     * @param array $condition 查询条件数组
     * @param obj $page 分页对象
     * @return array 二维数组
     */
    public function getGoodsList($condition,$page=''){
        $param  = array();
        $param['table'] = 'activity_detail,goods';
        $param['join_type'] = 'inner join';
        $param['field'] = 'activity_detail.activity_detail_sort,goods.goods_id,goods.store_id,goods.goods_name,goods.goods_price,goods.goods_image';
        $param['join_on']   = array('activity_detail.item_id=goods.goods_id');
        $param['where'] = $this->getCondition($condition);
        $param['order'] = $condition['order'];
        return $this->select1($param,$page);
    }
    /**
     * 构造查询条件
     *
     * @param array $condition 查询条件数组
     * @return string
     */
    private function getCondition($condition){
        $conditionStr   = '';
        if($condition['activity_id']>0){
            $conditionStr   .= " and activity_detail.activity_id = '{$condition['activity_id']}'";
        }
        if (isset($condition['activity_detail_id_in'])){
            if ($condition['activity_detail_id_in'] == ''){
                $conditionStr   .= " and activity_detail_id in ('')";
            }else{
                $conditionStr   .= " and activity_detail_id in ({$condition['activity_detail_id_in']})";
            }
        }
        if(isset($condition['activity_detail_state_in'])){
            if ($condition['activity_detail_state_in'] == ''){
                $conditionStr   .= " and activity_detail_state in ('')";
            }else{
                $conditionStr   .= " and activity_detail_state in ({$condition['activity_detail_state_in']})";
            }
        }
        if ((string) $condition['activity_detail_state'] !== ''){
            $conditionStr   .= " and activity_detail.activity_detail_state='".$condition['activity_detail_state']."'";
        }
        if($condition['gc_id'] != ''){
        $conditionStr   .= " and goods.gc_id='{$condition['gc_id']}'";
        }
        if($condition['brand_id'] != ''){
            $conditionStr   .= " and goods.brand_id='{$condition['brand_id']}' ";
        }
        if($condition['name'] != ''){
            $conditionStr   .= " and goods.goods_name like '%{$condition['name']}%'";
        }
        if(intval($condition['item_id'])>0){
            $conditionStr   .= " and activity_detail.item_id='".intval($condition['item_id'])."'";
        }
        if($condition['item_name'] != ''){
            $conditionStr   .= " and activity_detail.item_name like '%{$condition['item_name']}%'";
        }
        if(intval($condition['store_id'])>0){
            $conditionStr   .= " and activity_detail.store_id='".intval($condition['store_id'])."'";
        }
        if($condition['store_name'] != ''){
            $conditionStr   .= " and activity_detail.store_name like '%{$condition['store_name']}%'";
        }
        if ($condition_array['goods_show'] != '') {
            $condition_sql  .= " and goods.goods_show= '{$condition_array['goods_show']}'";
        }
        return $conditionStr;
    }
}
